sql select

The second method is to use something similar to an SQL SELECT statement .

第二种方法是使用某种类似于SQLSELECT语句的东西。

Fetching data from the database using the SQL SELECT query .

使用SQLSELECT查询从数据库取回数据。

A custom query is a wrapper around a user-defined SQL select statement .

一个通用的查询包围了用户定义的SQL选择申明。

Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause .

可以把这个函数看作相当于带WHERE子句的SQLSELECT语句。

An SQL select statement that will be executed to retrieve several rows from the database

一个SQL选择语句，它从数据库中获取几行

Note : This is the equivalent to adding a where clause in a SQL SELECT statement .

注意：这相当于在SQLSelect语句中增加一个where子句。

The table-reference variable is then used for the SQL Select statement FROM clause .

然后，表引用变量被用于SQLSelect语句FROM子句。

SELECT : Returns a set of variable bindings that satisfy the query ( similar to SQL SELECT ) .

SELECT：返回满足查询的一组变量绑定（类似SQLSELECT）。

First , the DataGrid will auto-generate all columns returned by the SQL select statement .

首先，DataGrid会自动生成从SQLselect语句返回的所有列。

Just create the indexes and add the where clause to your SQL select statements , and you are good to go .

只需创建索引并在SQLselect语句中添加where子句，就会使用索引。

We will see a little later how to work with SQL SELECT query and the result set using the FESI database access extension .

我们不久后将看到如何使用SQLSELECT查询及运用FESI数据库访问扩展名的结果集。

Imagine running a SQL SELECT statement and merging the results directly into an HTML table marked up to your specifications .

想象一下，运行一个SQLSELECT语句，并将结果直接合并到一个符合自己的规范的HTML表格中。

So the N extra SQL select statements on pojoB were cut down to N / 10 .

因此N次额外的关于pojoB的selectSQL语句被减少到了N/10次。

Do you remember how to restrict SQL SELECT statements to return only rows for customers living in zip code 95116 ?

还记得怎样限制SQLSelect语句，使之仅返回居住在邮政编码为95116的地区的客户的行吗？

From there , you can call the eachRow () method , passing in the SQL select statement as a method argument .

这时，可以调用eachRow（）方法，传递SQLselect语句作为一个方法参数。

The method builds a SQL select , and then defers the creation of the domain to the createDomain method .

此方法构建一个SQLselect，然后会将域的创建延迟到createDomain方法。

Each data source is then read by a simple SQL SELECT statement , and the join is completed within the InfoSphere DataStage process .

只通过简单的SQLSELECT语句对每个数据源进行读取，并且在InfoSphereDataStage流程之内完成连接。

The row specifying the column is used to populate the SELECT , FROM and ORDER BY clauses of the SQL select statement .

指定列的行用来组成SQLselect语句的SELECT、FROM和ORDERBY子句。

QuerySQL & Any valid SQL select statement that retrieves the XML document ( s ) that need to be updated .

querySQL&任何用于检索需要更新的XML文档的有效SQL选择语句。

The first rule is to always provide only the exact columns that you need to retrieve in the SELECT-list of each SQL SELECT statement .

第一条规则是始终在每条SQLSELECT语句的SELECT列表中只提供确实需要检索的那些列。

An Open SQL select clause always needs a data structure where it can put the results of the call , such as a structure or an internal table for bulk calls .

OpenSQLselect子句总是需要一个数据结构，比如结构或内部表（对于大量调用），它要把调用的结果放在这个数据结构中。

Since we are now using SQL SELECT statements , the restore_where argument changes from a Perl pattern match to the syntax of an SQL WHERE clause .

因为现在使用的是SQLSELECT语句，所以restorewhere自变量从Perl模式匹配改成SQLWHERE子句。

Also , so that this article 's code could illustrate and test the construction of the SQL select , ActiveRecord has a $ select property that is set in createDomain .

同时为了让本文的代码能够充分展示并测试SQLselect的构造，ActiveRecord具有一个在createDomain内设置的$select属性。

Again an SQL select statement can be built up according to one or more predicates ( possibly established from primary keys in the incoming message , as identified by XPath expressions ) .

同样，可以根据一个或多个谓语构建SQLselect语句（根据XPath表达式的确认，还可以根据传入消息的主键建立）。

Besides specifying the format of the data that is to be written to the output file , you must also provide the name of that file , and an SQL SELECT statement to specify the data that is to be exported .

除了要指定写到输出文件中的数据格式之外，还必须提供该文件的名称和一个用于指定输出数据的SQLSELECT语句。

SQL default select conditions are stored in the declaration of an SQL record .

SQL缺省选择条件被存储在SQL记录的声明中。

Edit SQL default select conditions

编辑SQL缺省选择条件

Then , you define an SQL statement to select the data from the database , which is executed using sql : execute .

然后，定义一个SQL语句来从这个数据库选择数据，此数据库用sql：execute执行。

You simply write an SQL / XML SELECT statement that invokes the XMLTable function and use this as a basis for your view definition .

您只需编写一个SQL/XMLSELECT语句，在语句中调用XMLTable函数，并以此作为视图定义的基础。

It can be used in the WHERE clause of an SQL statement to select only the rows that return non-trivial XML values for the XPath expression .

可以在SQL语句的WHERE子句中使用它只选择那些对于XPath表达式返回非空XML值的行。